﻿CREATE TABLE [dbo].[tblCirculation]
(
	[CirculationID] INT NOT NULL PRIMARY KEY IDENTITY(600, 1), 
    [CirculationType] INT NOT NULL, 
    [CirculationDate] DATETIME NOT NULL, 
    [CirculationProductInstanceFK] INT NOT NULL, 
    [CirculationCityFK] INT NOT NULL, 
    [CirculationWarehouseFK] INT NOT NULL, 
    CONSTRAINT [CirculationProductInstanceFK] FOREIGN KEY ([CirculationProductInstanceFK]) REFERENCES [dbo].[tblProductInstance]([ProductInstanceID]), 
    CONSTRAINT [CirculationCityFK] FOREIGN KEY ([CirculationCityFK]) REFERENCES [dbo].[tblCity]([CityID]), 
    CONSTRAINT [CirculationWatehouseFK] FOREIGN KEY ([CirculationWarehouseFK]) REFERENCES [dbo].[tblWarehouse]([WarehouseID])


)
